-- Create table
create table YL_OMS_ORDER_TRANSFER
(
   ID                          bigint                    comment  '订单ID'
   ,WAYBILL_ID                 string                    comment  '运单号'
   ,TERMINAL_DISPATCH_CODE     string                   comment  '三段码'
   ,DISPATCH_NETWORK_CODE      string                    comment  '派件网点编码'
   ,DISPATCH_NETWORK_NAME      string                    comment  '派件网点名称'
   ,LAST_CENTER_CODE           string                    comment  '集包地编码'
   ,LAST_CENTER_NAME           string                   comment  '集包地名称'
   ,INPUT_TIME                 date                    comment  '订单录入时间'
   ,CREATE_TIME                date                     comment  '创建时间'
   ,NEW_TERMINAL_DISPATCH_CODE string
)
COMMENT '转寄件原单信息'
PARTITIONED BY (
  `dt` string COMMENT '分区(yyyy-mm-dd)')
STORED AS PARQUET
LOCATION
  '/dw/hive/jms_ods.db/external/YL_OMS_ORDER_TRANSFER';